Labels:text | font | screenshot | diagram OCR: FIGURE . 1: After loading data into the data-warehouse detail tables, you can create a summary as a materialized view. OradeBl can then rewrite a summary query that targets the detail tables to access the materialized view, for faster response time, By refreshing a materialized view, you can keep the summary data consistent with the underlying data in the detail tables. You can also use Oraclesi's summary advisor to analyze the benefit of existing and potential materialized views. OLTP Database Incremental Extraction of New Detail Data Data Warehouse Application, iQuery Auto Query Rewrite Scheduled Summary Refresh Analysis of Existing and Potential .. Malegalized View Summary Tables (Surchary Table)
(1999).iso/oracl/991/bobrf101.gif){kind=small}
(1999).iso/oracl/991/bennf103.gif){kind=link}
(1999).iso/oracl/991/coucf202.gif){kind=link}